﻿<!DOCTYPE html>
<html>
	<head>
		<title>NUMBERVALUE Function</title>
		<meta charset="utf-8" />
		<meta name="description" content="" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
			<h1>NUMBERVALUE Function</h1>
			<p>The <b>NUMBERVALUE</b> function is one of the <a href="../UsageInstructions/InsertFunction.htm#textdata" onclick="onhyperlinkclick(this)">text and data functions</a>. Is used to convert text to a number, in a locale-independent way. If the converted text is not a number, the function will return a <b>#VALUE!</b> error.</p>
			<h3>Syntax</h3> 
			<p><b><em>NUMBERVALUE(text, [decimal_separator], [group_separator])</em></b></p> 
			<p>The <b>NUMBERVALUE</b> function has the following arguments:</p>
            <table style="width: 40%">
                <tr>
                    <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                    <th style="background-color: #f4f4f4"><b>Description</b></th>
                </tr>
                <tr>
                    <td><b><em>text</em></b></td>
                    <td>The text data that represents a number.</td>
                </tr>
				<tr>
                    <td><b><em>decimal_separator</em></b></td>
                    <td>The character used to separate the integer and fractional part of the result. It is an optional argument. If it is omitted, the current locale is used.</td>
                </tr>
				<tr>
                    <td><b><em>group_separator</em></b></td>
                    <td>The character used to separate groupings of numbers, such as thousands from hundreds and millions from thousands. It is an optional argument. If it is omitted, the current locale is used.</td>
                </tr>
            </table>
			
			<h3>Notes</h3>
            <p><a href="../UsageInstructions/InsertFunction.htm#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>NUMBERVALUE</b> function.</p>
			
			<h3>Examples</h3>
            <p>The figure below displays the result returned by the <b>NUMBERVALUE</b> function.</p>
			<p><img alt="NUMBERVALUE Function" src="../images/numbervalue.png" /></p>
		</div>
	</body>
</html>